Step One - Import Data

Here we import the Victoria spatial data for suburbs and the expentiture dataset. Once completed this will give a value per suburb in a format that can be mapped. The expenditure dataset is a bit horible to get location names out of and there are a mix of suburb names, LGA names, regions and a mixof other spatial scales. Cleaning this is endless and I have to draw the line and move on.

## OGR data source with driver: ESRI Shapefile 
## Source: "mapping", layer: "SSC_simple"
## with 8529 features
## It has 4 fields

Calculate Expenditure per Location

Some expenditure goes to multiple locations so this needs to be split out first. Then expenditure is summed for single locations.

Join Locations and Expediture to Suburbs

Some suburb names needed to be modified so that the Expenditure dataset and Suburbs spatial data would match. The plot below indicates the locations that have not been allocated to a suburb.

Import Population Data

The population data is needed to calculate the expenditure per person for each Suburb. Again there is a problem with matching the location data. The State based Suburb data is not compatible with the ABS based population data. The ABS data contains roughly half the number of suburbs and so cannot be directly linked.

Merge Suburb and Population Data

Merge is made on the ABS suburb ID

Merge with Spatial Data

The Map

Here is the basic map. The data is in GeoJSON format so it can be saved and used outside of R.

Attemped LGA Translation

I had hoped to capture some of the expenditure directed to LGA’s. Currently this is on hold.

Revenue